Defining a new label and field format
Next, you define a new label and a new format for this field. Leave the repeating value to the default no.
|
To define a new label and a new format for a field, perform these steps: |
- Type Price/Line as the new label.
- Type >,>>>,>>9.99 as the new format:
- The greater than symbols (>) are space holders for digits. A blank space replaces the > if there is no digit in that position.
- The comma (,) acts as a place holder. This character displays literally in the value.
- The 9 is replaced by a digit from 0 to 9. A zero replaces the 9 if there is no digit in that position. Because two 9s follow the decimal point, Results displays only two digits after the decimal point.
- The decimal point marks the location of the decimal point in the field. This character displays literally in the value.
- Press GO or RETURN.
- Run the report to your terminal.
- Press END to return to the Report Layout window.
This format means that the field can have up to seven digits to the left of the decimal and two digits to the right. It will also display in a right-justified format. Results does the following to the fields format:
-E) startup option), numbers on your screen appear in European numeric format. In European numeric format, a comma (,) marks the decimal location in fields and a period point (.) acts as a place holder. For example, with your format set for European display, the format >,>>>,>>9.99 appears as >.>>>.>>9,99. For more information about field formats and the -E startup option, see Appendix C "Field Display Formats."
The new field appears in the Report Layout window. Note that the report layout is too wide to display on the screen. Use the > and < keys to scroll to the left and right of the Report Layout window to see all the field format.
The *n marker tells you that this is a numeric expression field. In this case, it is a math expression field:
Again, use the > and < keys to scroll left and right across the page to see all the field values.
There are a couple of things you can do to make this report easier to read and more meaningful. You can change the label and format of some of the fields so they fit within the screen. You can also hide repeating values so you do not see the customer name or order number more than once.